sqlREPORTS - Alpha Order

Report Name

Listed in Category

Report Description

Restricted

504 Students for a School

Health

This report will list any student within a selected school that has a Y in the

504 field or has a comment in the Alert_504 text field.



504, SPED and ELL Listing


Misc Student Listing

This report will display any active student with SPED, 504 or ELL indicators. Since a student can't have an IEP and a 504 at the same time, there is a 504 Err column to identify these errors.

NOTE: This report must be run within a school.



Active Teachers Summary


Data Management

This report will list each school with the total of teachers assigned to the school, the number of lead teachers assigned to an active class and the

number of substitute teachers.


Restricted


Absences by Student


Attendance

This report lists all students in a specified school along with their Grade Level, Homeroom, Absences (Unexcused, Excused & Medical Absences), OSS, Tardy and Total Days absent.



Absent Report for a Student


Attendance

This report will list every Absence and Tardy, including the school attended at the time, for a select student (be sure to select student before selecting sqlReports tab) for their entire history in Bridgeport School District .



Active Counselors


Staff

This report will list all active counselors along with the school they service. The listing is based on the school, therefore, a counselor may appear multiple

times if they service more than one school.


Active ELL Students with Creation Date

Bilingual

The intention of this report is to list only ELL students within a school and the

date their record was either created or imported from SASI.



Active Staff Listing


Staff

This is a listing of all currently active staff with an active PowerSchool account. Please note, having an active PowerSchool account does not insure you have access to the PowerSchool databases. Also note, this report must be run within a school, not at District level. Please report any staff members no longer at your school to the Data Management Dept.



Active Staff Listing


Data Management

This is a listing of all currently active staff with an active PowerSchool account. Please note, having an active PowerSchool account does not insure you have access to the PowerSchool databases. This version of the

report can be run at any level but will return active staff District wide.



Active Staff Listing for District


Staff

This is a listing of all currently active staff with an active PowerSchool account within the entire District. Please note, the staff member may appear more than once. The reason is that the staff member may be active at more than one location. Also, having an active PowerSchool account does not insure you have access to the PowerSchool database.


ADA for All Schools

Attendance

Report to display Average Daily Attendance for all schools between a date

range

Restricted

Administrative Transfers

Control Transfers

Listing of all students marked as having an Administrative Transfer whether

active or inactive.



Alerts List


Health

Shows students with built-in alerts (discipline, guardian, medical, other). Hover over the icon to see the alert text. Can be run for the entire student

body or just the current selection.



All Log Entries for a Student Within a Date Range

Discipline and Other Log Entries

This report is intended to list all Log Entries for a single student within a date range. You have first selected a student or group of students but only one

will be listed at a time.



Annual Review


Bilingual

This report will list all high school ELL students along with the school they are attending and the their ESOL teacher if the student is attending an ESOL class. If the student is not attending an ESOL class the teacher will be

designated as "Unassigned"



Aqua Q1 Grades to Export


Aqua & Magnet Schools

The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q1 report will include Q1 letter grade and percent along with the number of

absences.



Aqua Q2 Grades to Export


Aqua & Magnet Schools

The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q2 report will include Q2, E1, S1 and Y1 letter grade and percent along with

the number of absences.



Aqua Q3 Grades to Export


Aqua & Magnet Schools

The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q3 report will include Q3 letter grade and percent along with the number of

absences.



Aqua Q4 Grades to Export


Aqua & Magnet Schools

The purpose of this report is to collect the Stored Grades from out of District students attending Aqua Culture and export them to the resident towns. The Q4 report will include Q4, E2, S2 and Y1 letter grade and percent along with

the number of absences.


Aquaculture Course Enrollment

Enrollment - Course

Lists all students enrolled in all classes given at Aquaculture


Assignment Scores Info by Teacher

Grades

Choose a teacher and the report will show when scores were last updated.



Attendance Intervention Report


Attendance

The purpose of the Attendance Intervention Report is to list all active students, with the exception of Pre-K students,within a selected school that have 2 or more unexcused absences for the entire current school year, no matter what school the students was attending this year. The the dates from the each activity contained on the Special Attendance page will also be

dispalyed.


Attendance and Absence Rates by Date

Attendance

This report list the number of students absent, school membership, absence

rate, and attendance rate by date.

Restricted

Attendance by Grade for Today

Attendance

The purpose of this report is to provide a simple attendance of active

students for today only.



Barcodes Captured in PowerSchool


Data Management

This report is for use by ITS to review device barcodes recorded in PowerSchool and may not be captured in the Snipe-IT asset management

system.


Bilingual Assessment Worksheet

Bilingual

This is a first attempt to provide Bilingual teachers a uniform spreadsheet for

reporting purposes



Bilingual Classes for District


Bilingual

This report is designed to show all the bilingual homerooms in the District along with the teacher and class count. The report is based on the teacher designation as 'Bilingual'. If the teacher is not marked as 'Bilingual' in the demographics page or if the teacher is no longer a bilingual teacher, the

report will be incorrect.



Bilingual Newly Arrived


Bilingual

This report attempts to identify students that may need bilingual services who have just arrived. This report is based on all active students that have answered one of the first three questions on the Home Language Survey with a language other than English (001). In order to filter only those students from the date chosen, the entry date is compared to any re-enrollment records that may precede the entry date.


Restricted

Bilingual Newly Arrived Summary

Bilingual

ELL Students who were entered into PowerSchool after 7/1/2017



Bilingual Students Requiring Testing


Bilingual

The intention of this report is to identify those students who have completed the Home Language Survey and at least one of the first three questions was answered with a language other than English and they have not been

identified with an LDC code.


Birthday Listing

Misc Student Listing

This report will list all students within the school currently logged into that

have a birthday in the month chosen.



Breakfast Report


Nutrition

This reports on all elementary schools the enrollment total, total attendance for the day, the number for breakfasts served and those refused for a specific

day



Bridgeport Students Enrollment by School


Enrollment - School

The purpose of this report is to give a count of enrolled students in each school. This report includes all active students that attend a Bridgeport

Public School. This report excludes TUS, NRP, OOD and BJDC.



Bridgeport Truancy


Attendance

This report lists the students with the number of unexcused absences as defined by the criteria selected. It is the same report that appears on the 'System Reports' page but due to the PowerSchool upgrade it isn't working

properly.


Bullying Allegations Report

Discipline and Other Log

Entries

Listing of students that reported being bullied and when and who were the

alleged bullies.


Bus Counts for District

Transportation

Counts active students who are assigned a bus number



Bus Listing Greater Than 25


Covid Related Reports

This report is based on only those Covid Survey responses that have replied 'Yes' the student was returning to school. Therefore, the 'Total' may not be the total number of students assigned to the bus, only those confirmed they are returning to school. The buses listed are only those buses that have 26 or more 'Total' students for that bus. Those parent that replied that they would drive their child to school are counted as 'Refusing Bus'. Subtracting this number from the 'Total' will result in the number of riders on the bus.



Bus Listing Less Than 26


Covid Related Reports

This report is based on only those Covid Survey responses that have replied 'Yes' the student was returning to school. Therefore, the 'Total' may not be the total number of students assigned to the bus, only those confirmed they are returning to school. The buses listed are only those buses that have less than 26 'Total' students for that bus. Those parent that replied that they would drive their child to school are counted as 'Refusing Bus'. Subtracting this number from the 'Total' will result in the number of riders on the bus.


Bus Lists By School

Transportation

Bus list containing students listed by bus number



Bus Stops By School


Transportation

This report will list the bus stops and a count of the number of students at that stop for a particular school. The report is driven by the data exchange between active students in PowerSchool and the information received nightly

from Transfinder.


CSA Supper Listing

Nutrition

Report will list all students Present for the date submitted for Classical

Studies and the Annex in one listing



Calculate Insession School Days


Miscellaneous

The purpose of this report is to determine the number of school membership days between two dates. NOTE: You need to be logged into a school in order

to run report.


Capacity vs Enrollment

Data Management

Capacity vs Enrollment for each School in the district.



Child Find Report for a School


Attendance

Child Find Report lists all students within a selected school that have 2 or more unexcused absences and will list the Child Find activity contained on

the Special Attendance Support page.



Chronic Absenteeism Current Summary for a School


Attendance

This report must be run within a school and will result in the current enrollment, non-chronic total, chronic total and chronic percentage for that school as of today.

NOTE: This report is intended to help the school improve their attendance by reporting the data available at the moment. The official report is produced at the end of each day. As a result of these report being produced at different times, the data from the two reports may vary slightly.



Chronic Absenteeism Report - Student Listing


Attendance

The is a similar report to the Crystal Report sent via email. However, it may very slightly since this is a dynamic report using real-time data. Whereas, the Crystal Report is run nightly. This is one report for all schools, therefore the Conslr/HR RM field for Elementary is the Homeroom room number and for High Schools, the field is the Counselor.

In addition, since the State is not concerned with Pre-K attendance, these grades are not included.


NOTE: Must be run within a school.



Chronically Absent


Attendance

USE THIS REPORT WITH CAUTION. THE CHRONIC REPORT FROM THE CRYSTAL SERVER THAT IS EMAILED TO SCHOOLS WILL BE USED AS THE "OFFICIAL" REPORT. THIS REPORT IS DONE BASED ON THE TIME IT IS RUN. THEREFORE, ANY ATTENDANCE CHANGES DONE WILL BETWEEN THE TIME THE CRYSTAL WAS DONE AND THIS REPORT WAS RUN WILL CAUSE A DISPARITY BETWEEN THE TWO REPORTS.

Students are chronically absent when they are absent 10% or more. This report includes all absences within this school regardless of excused or unexcused. NOTE: this report defaults to the school you are logged into. For District users, you should select a school prior to running this report unless you want each chronically absent student in the entire District.



Class Enrollment History (PST)


Teachers (PST)

Must be in PowerTeacher

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

Choose a section and see the enrollment history of students in that section.

Will show active and dropped students.


Restricted

Class Requests

Scheduling

Lists Student's course requests for next year.

Restricted


Claudia's School Days in a Month


Data Management

The purpose of this report is to give an exact count of school days within a specific month for each school based on their individual calendar.



College Level Enrollment & Prep.


Enrollment - Course

Report designed to count the students enrolled in an AP, Dual Enrollment or any of the College & Career Prep. for any of the high schools.

NOTE: Since Dual Enrollments are College Level, the numbers are not included in the cross total. Otherwise the totals would be doubled for those courses.



Control Transfer Listing


Control Transfers

This a list of all students who have been designated as being on a Control Transfer. Since the report is to be used for data cleaning, both active and

inactive students are included.



Control Transfer Report


Control Transfers

This report will select only those students within a particular school who's Control Transfer is checked and will display the revoke dates and reasons

that are filled in.


Control Transfers No Longer at CT School

Control Transfers

Listing of students given Control Transfers but no longer at Control Transfer

designated school



Control Transfers with Revocation Dates


Control Transfers

This report is intended to show any active student with a Control Transfer that have been given a Revocation Letter. This will also display those students that have received a final revocation but are still marked as a Control

Transfer.


Course Enrollment for CL by School

Enrollment - Course

This report counts the students enrolled in a College Level courses only by

the school the course is given.


Course Totals by Grade Level

Enrollment - Course

The total number of students at the current school enrolled in a course,

broken down by grade levels.

Restricted


Courses Used in Wrong Term


Data Management

The purpose of this report is to identify high school courses with active sections using the wrong course for the term. If a course was created as a year long course and achieving 1 credit for that time period it would have a 'Y' as the 6th character in the course number. Therefore, if the course is used for a semester course which would typically earn 0.5 credit, at the end of the semester the student would actually earn 1 credit.

NOTE: Credit Recovery (CR) courses are not included in this report.



Covid Responses School Summary


Covid Related Reports

This report is the summary for the current school of all active students for the purpose of identifying those parents that responded to the Covid Survey for the 2002-21 school year and those that did not. Along their response is their answer to the question of driving their child to and from school. Included in the report is the bus number if the student is eligible. An additional column was created to determine if the student does have a bus route but the parent answered 'Yes' to driving the student to and from school then 'Yes' appears in 'Refused Bus' column.

RUN WITHIN A SCHOOL



Covid Survey Page with Barcode


Covid Related Reports

The purpose of this report is to list all students and the current data on the Covid Survey page including the barcode of the device if one was loaned to the student.

MUST BE RUN WITHIN A SCHOOL



Covid Survey Responses


Covid Related Reports

The purpose of this report is to list all students and their parents' responses to the Covid Survey taken for the upcoming 2020-21 School year. Included is the response whether or not the parent will drive the student to school and the bus information from PowerSchool if the student is eligible busing. An additional column, 'Refused Busing' was added to indicate if the student was given busing but the parent has elected to drive the student both to and from school then the column will be 'Yes'.

RUN WITHIN A SCHOOL



Covid Survey Responses - District Wide


Covid Related Reports

This report lists all active students in Bridgeport Public Schools for the purpose of identifying those parents that responded to the Covid Survey for the 2002-21 school year and those that did not for the entire District. Along their response is their answer to the question of driving their child to and from school. Included in the report is the bus number if the student is eligible. An additional column was created to determine if the student does have a bus route but the parent answered 'Yes' to driving the student to and from school then 'Yes' appears in 'Refused Busing' column.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.


Restricted


Covid Survey Responses - Summary


Covid Related Reports

This report is the summary by school of all active students in Bridgeport Public Schools for the purpose of identifying those parents that responded to the Covid Survey for the 2002-21 school year and those that did not for the entire District. Along their response is their answer to the question of driving their child to and from school. Included in the report is the bus number if the student is eligible. An additional column was created to determine if the student does have a bus route but the parent answered 'Yes' to driving the student to and from school then 'Yes' appears in 'Refused Bus' column.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.


Restricted

Creator Summary

Student Support Services

A summary count of all Student Support visits created by an individual

throughout the District.



Current Classes (PST)


Teachers (PST)

Must be in PowerTeacher

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

This report will show where students are enrolled in on the current day based on the period entered in the first box below. You can run the report for just a section or for the entire student body. Students with free periods will not appear on the report. Only enter one period and only enter the period number. For example, you only need to enter 2 for period 2, regardless if it's

2(A), 2(B), 2(A-B), etc.


Restricted


Current Course Enrollment


Enrollment - Course

The intention of this report is to give and up to date account of the number of students enrolled in a class. As students are moved from one class to another, the section counts are not always accurate. This report uses the CC enrollments table not the Sections table which could have a delay before the

student total is updated.



Current Enrollment by School by Grade


Enrollment - School

The intention of this report is to quickly give an enrollment count at the time it is run. These counts may differ from the monthly reports and reports submitted to the State for the simple reason, enrollment numbers are always changing.

Included in the report is the "Type" this allows the user to select only high schools (HS), elementary (EL), unique programs (PGM) or special application

schools (SP).



Current Interdistrict Student Enrollment


Finance

This is a list of the currently enrolled out of district students for use as supporting documentation when submitting tuition statements to other

Districts.


Restricted

Daily Attendance Review

Attendance

The purpose of this report is to review the 'daily' attendance recorded for all

students within a school.


Discipline Entries by Grade Level

Discipline and Other Log

Entries

This report counts the number of discipline entries by grade for a school

within a particular time frame.


Discipline Entry Count by Author

Discipline and Other Log

Entries

Count the number of discipline entries a person has created within a school.

Restricted


Discipline Log Entries (PST)


Teachers (PST)

Must be in PowerTeacher

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

This report will show discipline log entries of all the students a teacher has in class. The log entries will start based on a date entered by the teacher.


Restricted


Discipline Log Entries by Student

Discipline and Other Log Entries

This report allows an admin to search for discipline log entries for a student in the current school. The search will be based on dates entered by the admin.


Restricted


District Enrollment Summary


Covid Related Reports

This report shows the total enrollment within each school in the District with the total students using in-school learning and those using distant learning. Note: if the Covid Survey question of 'Is the student returning' is blank the

assumption is distant learning.



District ISS, OSS Historic Data


District

This report will count the Unique Students and the total number of ISS and OSS Discipline Logs and number of days by the month for the entire District from 2014 to present.


Please Note: During the current year the disciplinary sanctions will change as the discipline logs are edited. As a result, the data reflected in the report will change as the year comes to a close. The previous years' data should remain the same.



District Present Count


Data Management

This report will show the number of Bridgeport students present, absent and enrolled in Bridgeport Schools on any school day for any year. For the purposes of this report the students enrolled in the following are not included in this report Non Reporting, Out Of District, Aqua Culture, TUS, and BJDC



District Present Count with Remote


Data Management

This report will show the number of students present and absent for both In School and Distant Learning for the entire District on a specific day. Please the purpose of this report is to show the overall presence of Bridgeport students attending a Bridgeport Public school. Therefore students enrolled in the following are not included in this report Non Reporting, Out Of District,

Aqua Culture, TUS, and BJDC



District Schools


Data Management

List report will list all schools within the school table or jusr those that are currently active, including those non schools like OOD, NRP and others.



District Wide All Students Home Lang. Survey


Home Language Survey

This is a District listing of all students in all school with the exception of OOD and NRP. The report details the Home Language Survey results for the

student in addition to the 504, SPED and Ell indicators.



District Wide Home Lang. Survey ELL ONLY


Home Language Survey

This report will list every student in the District currently marked as ELL and list their Home Language Survet results for questions 1 through 6. Also

included in the student details is the LDC and ELL Code.


Restricted


Duplicate Course Enrollment


Enrollment - Course

This report will list all students within a school who are currently actively enrolled in the same course in more than one section. The last two columns indicate if the course gives grades (Grades) and takes attendance (Attn).

These duplicate enrollments will have an adverse effect on the students final grade and their attendance.

MUST BE RUN WITHIN A SCHOOL



Duplicate Course Enrollment for District


Data Management

This report will list all students throughout the District who are actively enrolled in the same course in more than one section. The last two columns indicate if the course gives grades (Grades) and takes attendance (Attn).

These duplicate enrollments will have an adverse effect on the students final grade and their attendance.



Duplicate Stored Grades


Data Management

This report will list any student with duplicate grades that were stored in the the same marking period. Included in the list is the course number and the section number. Any stored grade for a student who is no longer enrolled in

that course will display 'Inactive CC'.



Duplicate Storedgrades


Uncategorized

The purpose of this report is to identify students with more than one stored grade of a marking period. This may indicate the student is enrolled in more

than one section of the same course number.


ELL Code Errors

Bilingual

This report lists ELL students throughout the District that have an ELL Code

that may not be correct.


ELL Students By School

Bilingual

Listing of all ELL students for a selected school. With the ability to make the

listing the "Current Student Selection".


ELL Total Count by School

Bilingual

This report displays a simple count of all students with a "Y" in the ELL status

code.


ELL is N but LDC is A, B or X

Bilingual




Early Childhood Pre-K Readiness/Smart Start


Early Childhood

List of individual Pre-K students and their classroom with other information to help compile data for School Readiness and Smart Start Reporting


Early Childhood Pre-K Student Listing

Early Childhood

Listing of all active Pre-K students throughout the District for the current

school year



Early Childhood Teacher Listing by Grant


Early Childhood

This District wide report lists all schools with Pre-K classes and listing those teachers that are operating under a grant of any kind, as denoted on the demographics page along with the total number of students in their class.



Elementary All Homeroom Count


Covid Related Reports

Using the Covid Survey Response 'Yes' to returning to school, this report identifies all homeroom within a school. This report uses the room number in the Section to identify classrooms. The grade of 'mixed' is for those self contained classrooms that will have different grade levels in the same room. The accuracy of this report is based on the accuracy of the room number and whether or not the teacher is identified as Special Ed.



Elementary Classes Current Year (PST)


Teachers (PST)

Must be in PowerTeacher

This report is intended for elementary 'Specials' teachers. It shows their scheduled classes for the current year and the homerooms associated with that class. NOTE: You must be logged in as a elementary teacher.


Restricted


Elementary Daily Attendance


Attendance

The intention of this report is to list every active student and their daily attendance for a specific day. In order to be sure each student as a daily attendance record for the date being reviewed. The 'Daily Att Code' column is the attendance code that has been entered for the day. The dash ('-') in this column signifies that there isn't any attendance code for the day, however, the default will be 'Present', indicating an in-school presence. The column labeled 'Meet Codes' is a collection of all the codes taken during the day for this student by the teachers. For example, a student may have a Meet Codes like 'VAB,VAB,VAB,VP,VP'. This means 5 teachers entered an attendance for this student on that particular day. Please be aware if attendance was taken and the student was present in school and in the class, the default is blank.

Therefore, the student may have a 'Meet Codes' looking like this 'ABSNT,TRDY' but the student was present for the remainder of his classes and may have a '-' for the daily attendance code. This report must be run from within a school.



Elementary Grades Averages 80 and Above


Grades

This Report lists students in grades 6, 7 and 8 with an average of 80% or better. This average is based on the Y1 percent grade in the teachers' Gradebook. Grades for terms not entered are not included in the average. Students with failing grades but still maintaining an 80 or above average are still included.


NOTE: Report must be run from the within a school



Elementary Homeroom Count


Covid Related Reports

Using the Covid Survey Response 'Yes' to returning to school, this report identifies any elementary homeroom with 15 or more students in the classroom, regardless of the number of students enrolled in the class. This is a District wide report and uses the room number in the Section to identify classrooms. The grade of 'mixed' is for those self contained classrooms that will have different grade levels in the same room. The accuracy of this report is based on the accuracy of the room number.



Elementary Homeroom Listing


Enrollment - Course

This report is intended to provide an alphabetical listing of all students within an elementary school and their Homeroom assignment. This report is based on the actual course enrollment. Therefore, it is the most current, whereas the Homeroom listed on the student header is only updated nightly. In addition, this report will show those students not enrolled in a Homeroom.



Elementary Rosters for District


Covid Related Reports

The purpose of this report is to list all elementary schools and all students in the teacher's homeroom. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'.

Please note because it is District based, it take may take up to 5 minutes to run.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.


Restricted


Elementary Rosters with Distance Learning


Covid Related Reports

The purpose of this report is to list all students in the teacher's homeroom within the school you are currently logged into. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'.

RUN WITHIN A SCHOOL



Elementary Rosters with Hybrid Days


Covid Related Reports

The purpose of this report is to list all students in the teacher's homeroom within the school you are currently logged into. The report is similar to the previous roster report but is more focused on the students' on going school participation. Along with the student's Homeroom info there is the in-session days a student is to attend school. In addition, if your school has identified student's siblings, this report will display them if they are active in the same school.

NOTE: If the student is a Distance Learner, this will supersede the in-session days. However, in order to prepare for their return, you still want to schedule the in-session days.

RUN WITHIN A SCHOOL



Elementary Sections with wrong grade


Data Management

The purpose of this report is to identify those sections in the current school year for the elementary school where the grade level within the section does not match the grade level in the course number. For example SCI500 has a grade level of 0. This is very important because many of the reports are

based on the grade level entered in the section.



Elementary Term Grading Report


Grades

This Report lists students in grades 6, 7 and 8 with a minimum of 80% in all subjects with a specified marking period within a school.

NOTE 1: Report must be run from the within a school

NOTE 2: Homeroom typically have no grades and are therefore eliminated from the calculations.



Enrollment Stats


Enrollment - School

This report will display the total number of enrolled students currently. As well as the total number of females, males, non-binary and missing gender. Also included is the number and percentage of the following free or reduced lunches, Special Ed students and ELL students.

This must be run within a school.



Ethnicity/Race by Grade Level


Enrollment - School

This report lists the total ethnicity, race and gender for each grade level within a specific school. The total count is the number of students in that grade

level. with race completed.


Exited Students Within a Date Range

Enrollment - School

The purpose of this report is to display a list of students who exited school

within a date range.



Exited Students Without Withdrawal Form


Misc Student Listing

The purpose of this report is to identify those students that have been exited from school without a Withdrawal Form or a Request for Records.


Restricted


FTE ID's For All Schools in a Year


Data Management

The purpose is to identify the FTE ID for a school within a particular school year. You must be in the school year you want the FTE for. However, the

report only goes back to 2017-18 school year.



Failure Rate from Stored Grades


Bassick

This report lists teachers from the Historical Grades database. Grouped by Course, the report shows the total number of students, the number of "F's" and the Failure Rate (fail/total).


NOTE: This report searches the "Stored" grades table. This table will include teacher names that may not be in your school because this table stores the grades from new students entering from outside our District.

Also note that you need to be in a school to run the report. Running the report from District will take forever and may be pointless.



February Concussion Report


Health

This report is intended to report concussion incidents to the State for the District broken down by grade and gender. Since a nurse cannot diagnose a concussion, this report looks for the word "concussion" within the Assessment field of the Office Visit. If found the visit is added to the grade level count.

The report uses the date range from the start of the current school year until February 1 of the next year.


Restricted

Finacial Report from Student Page

Finance

The purpose of this report is to show all the invoices paid to outside services

by student District wide.

Restricted


GPA Errors in Historical Grades


Grades

This report will list all the errors having to do with the GPA's going back to the 2015-2016 school year (2500 term)based off of the letter grade. The intention is to identify grades that will impact the student's GPA. The quarterly marking period GPA's (Q1, Q2, etc.) will only impact the current quarter's Honor Roll. The Y1 grade will affect the student's final accumulative GPA. The current counselor and administrator are listed but the error may have been in a previous year and/or school. The errors can range from no GPA entered, to wrong Added Value, to missing percent grade, to incorrect GPA for the letter grade given.


NOTE: This report must be run from a school.



GPA's for all Students


Grades

This report will calculate the current GPA for each student based on the Y1 grades stored for the current high school. Therefore, if you run the report before the Q1 grades are stored and then run the same report after the store, those 'semester' courses will figure into the final GPA. The report allows you to filter, as a result you can select only a single grade.



Grade Level vs Grade by Credit Hrs


Misc Student Listing

The intention of this report is to list all students within a high school by their present grade assignment. Based on the student's earned credits it will determine what grade the student should be in. The first year of high school is calculated from the historical grades table. Using the earliest recorded year for grades stored when student was in 9th grade. If the student transferred into a Bridgeport high school, it is imperative the guidance counselor record the correct and complete information into the historical grades table. In addition, the report calculates if the student has repeated a grade by subtracting the student's first year of high school from the current school year and comparing the difference.

The data displayed in the report is the student number, name, 1st year of high school,repeat or not, current grade, DOB, age, SPED, ELL, number of credits earned and what the grade should be based on the credits.

NOTE: The grade level from credits is based on whether the student started school before 2019 when the required credits to graduate was 22.5 or after when the credits required are 25.

Also, this report does take a few minutes to run and must be run within a school.



Gradebook vs Stored Grades


Grades

Generate a report showing all the discrepancies between the grades in the Teacher's Gradebook and those stored in the permanent database for a

specific school and marking period.



Guidance Counselor Summary


District

This report will list all schools with enrollment total and the number of students each guidance counselor is responsible for as defined in each student record. If no counselor is assigned to a student, it is reported as "No

Cnslr".


Health Category Summary

Health

Counts the number of office visits to the nurse by the category that was

entered.

Restricted

Health Office Visits

Health

List a student's history of visits to the nurse

Restricted


High School Course Catalog for District


Course Catalog

This report lists all active courses for High Schools throughout the District. The list is by course name but contains the schema breakdown allowing you to filter by Department, Classification (STEM/Humanities), Tier, length of course (year long vs semester), Type (TD=Traditional, SC=Self Contained,

etc), Rigor and added GPA value.


High School Courses with Active Students

Course Catalog

This report is similar to the course catalog but only shows high school

courses that have active enrollment this current school year.



High School Daily vs ADA (Meeting)


Attendance

This report is intended to show any student that should have been marked absent based on the Meeting Attendance but does not have the date marked as an absence in the Daily Attendance. The reverse of this will also be shown where there is an absence in the Daily Attendance but the Meeting Attendance does not reflect an absence. The Meeting Attendance can be seen if you run the 'ADA/ADM by Date' for a student and chose Meeting Attendance and use the Period to Day calculation. The resulting display will indicate absences by a '0' in the 'Attendance' column.

The High School Daily vs ADA report can be run from any school or District level.



High School Next Year Request Summary


Scheduling

The intention of this report is to show a student's requests for next year. The report will count the number of requests, display the courses requested and total the number of possible credits. You must be within a high school to run

the report.



High School Rosters for District


Covid Related Reports

The purpose of this report is to list all high schools and all students on a teachers' roster by course. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '-'. Please note because it is District based, it take may take up to 5 minutes to run.

ONLY USERS WITH DISTRICT ACCESS CAN RUN THIS REPORT.


Restricted


High School Rosters with Distance Learning


Covid Related Reports

The purpose of this report is to list all students in a teachers' roster by course for the school you are logged into currently. Along with the student's name is their parent's response to the Covid Survey asking whether or not the student will be returning to school. If the response was 'Yes' then the it is displayed as 'In School'. If the response was 'No' then it is displayed as 'Distance'. If the parent didn't respond to the survey or the question it merely displays a '- '.

RUN WITHIN A SCHOOL



High School Scheduling Report


Scheduling

This report is intended to help schedule high school students. The report is based on the current year (not PowerScheduler). Students are listed by grade then alpha and will appear several times. Each line consists of the term and courses within that term. '20-21' is a full year course spanning S1 and S2.

Since we are running block schedules a semester course would take place in a quarter, therefore, there is a 'Term A' and a 'Term B' to identify quarter courses within a semester. This report must be run within a school.



High School Students in Wrong Grade Level


Misc Student Listing

The purpose of this report is to identify those students that should be in a different grade level based on their accumulated credit hours. Students with special needs may have more credits than necessary to graduate. Therefore, the report will identify these SPED students with more credits as a grade "13". Those student with more credits but without special needs will have a the

suggested grades as "99".



High School Teachers Count within a Department


Staff

This report will list a Subject/Department taught within the school and the number of teacher, teaching that subject for the current school year. The

subject is based on the first two digits of the course number.



High School Teachers and Subject Taught


Staff

Set for the current school year, this report will search all high schools with students enrolled in sections and list each teacher and their subject they are

teaching.


Home Bound Report

Health

Lists all active students which are marked as Homebound.

Restricted


Home Language Survey


Home Language Survey

This report will list every student in a school and list their Home Language Survey results for questions 1 through 6. Each student is marked ELL (Y or N) and the report allows you to filter the results.


Homebound Students by School

Misc Student Listing

A listing of current Homebound students within a specific school.


Homeless List by School

Misc Student Listing

List students with Homeless status


Homeless Listing for District

Misc Student Listing

This is available only to District Admins

Restricted


Homeroom Enrollment for Bilingual


Bilingual

The purpose of this report is to enable Bilingual to place newly arrived students in elementary schools that have enough room. This report lists all Elementary Homerooms throughout the District with the capacity and currently enrolled students along with the school and teacher.


Restricted


Homeroom Listing with Busing Info


Transportation

The report will list all active students by Homeroom along with their busing information or if they do not get busing. Please note, the homeroom is identified after a nightly process. If a student was enrolled into a new homeroom, the correct room number and teacher won't appear until the next

school day.



Homeroom Rosters for Testing


Enrollment - Course

With the purpose of testing in mind, this report will produce a list of all students enrolled in a homeroom class. The list will include the homeroom teacher, room number, grade, student number, student name, DOB, SASID, study ID, SPED, 504 and ELL data.

MUST BE RUN WITHIN A SCHOOL



ISS, OSS Historic Data from 9/1/2014


Discipline and Other Log Entries

This report will count the Unique Students and the total number of ISS and OSS Discipline Logs and number of days by the month.


Please Note: During the current year the disciplinary sanctions will change as the discipline logs are edited. As a result, the data reflected in the report will change as the year comes to a close. The previous years' data should remain the same.


Inactive Students with Active Classes

Enrollment - Course

This report will list all students that are inactive by way of Transferred Out or

Graduated but are still on active rosters.


Inactive Teachers with Classes

Staff

Lists all classes that have an inactive teacher as the lead teacher.



Inactive Teachers with Sections


Enrollment - Course

This report will display all sections within a school that are assigned to a teacher that is no longer at the school whether he or she moved to another Bridgeport school, moved out of the District or retired. With the newly added ClassLink system, it is imperative that sections are always up to date.



Incorrect Course Number Used


Scheduling

This report will list all courses within a school that have a .5 credit course being used as a 1 credit course and vice versa based on our present block schedule. This report will search the active section and can be used for any

school year but not in PowerScheduler..


Individual Student Entries

Student Support Services

Report details for all entries for an individual student selected by the drop

down menu.

Restricted


Instructional Time by Section and Term


Miscellaneous

The purpose of this report is to show the total amount of instructional or seat time that each section has for duration of the term it is being offered in.



Interdistrict Magnet Current Enrollment


Finance

The purpose is to help the Business Office report and invoice neighboring towns for tuition for their Magnet students. This is the same report as the 'Interdistrict Magnet Enrollment Estimate' but instead of being an estimate it reports the currently enrolled out of district students.


Restricted


Interdistrict Magnet Enrollment Estimates


Finance

The purpose is to help the Business Office prepare an estimate for our Magnet students to other Districts. According to Section 10-264l (m)(l) of the CT General Statutes, Bridgeport is mandated to provide an estimate to each District for the upcoming school year. The estimate is to include the number of students by grade to each school and the estimated per pupil cost of tuition by May 15th.


The accuracy of this reports depends entirely on the data entered for the "Next Year Grade" and the Pre-Registration of all out of district magnet students by May 15th.


Restricted


Intra-District Grades Report


Aqua & Magnet Schools

This report is intended to be used to send grades of non resident students to their home Districts. The report is generated from the stored grades for the current year. Only the permanent marking terms are being reported, not the Progress Report grades. Please note if no grades have been stored there will be no results. However, if the P1 grades were stored but not the Q1 grades, you will get a report with students, course and absences but no current grades.NOTE: The report must be run within a school.



Invalid CC Records in PowerScheduler


Next Year Reports

The purpose of this report is to identify those student who are no longer going to attend the school you are current signed into. Normally, these requests would not be filled but a last minute decision by the student could cause this to happen. These records should be removed from the PowerScheduler CC table. To correct, be sure the requests have been removed and perform another Load. This will remove the current CC records and write all new records thereby eliminating these erroneous records.



Invalid Requests


Next Year Reports

This report will list all students and their requests for next year courses that are no longer intend on going to the current school you are presently signed into. The determination of whether a student intends on coming to the current school is based on what the Next School is on the Scheduling Setup page.

For example, if a Columbus student intended to go to Bassick entered Course Requests but now is going to Aero and the requests were not removed, the student will appear in this report.



LAS Link Placement Students


Bilingual

This report will list students that have entered the District from the date selected to present. These students are either marked ELL or have answered the Home Language Survey with a language other than English for questions 1 through 3. The list will include their LAS Link Placement Overall

score if they have been taken.


Languages Used in District

Bilingual

This is a listing of all languages as reported in the student's record as Primary

Language.



Last Gradebook Update


Staff

This report will show those teachers who have not updated any grades the gradebook for a section based on the date you enter. The report does not look at updates regarding standards. Only sections that are in session on that date are shown. For example, if you enter a date that is outside the date range of S2 sections, then those sections are not included.



List of AP Teachers


Staff

This report provides of a list of teachers with active AP courses. The classes must have students actively enrolled for the teacher to be listed.


Lizette's Select School & Grade Report

Health

This report lists only active students attending Blackham, Cesar Batalla or

Read and only in grades K, 1, 3, 4 and 5


Locate Sections

Data Management

This query is used to identify a section when you only know the section ID


Log Entries by Author

Discipline and Other Log

Entries

This report is grouped by author and when expanded will list the category,

student and entry date.



Log Entries by Student (PST)


Teachers (PST)

Must be in PowerTeacher

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

Teachers can choose one of their students and a starting date and see any

discipline log entries that have been created for that student.


Restricted


Log Entry Summary


Discipline and Other Log Entries

The purpose of this report is to give admins a perspective of the number and types of student logs being create within the school for the current school year. The report will list the author of the log, whether currently in the school or not, and a count of each type of log that was entered.


Log Tally by Author

Discipline and Other Log

Entries

Counts all type of log entries by the author for a give time period.



Missing High School Homerooms


Enrollment - Course

This report will list all students within a high School that does not have a Homeroom scheduled. The courses used in high school homerooms are AD009YPLGE, AD010YPLGE, AD011YPLGE, AD012YPLGE, and

AD013YPLGE. The program does not specify first period.



Missing Historical Grades


Counselors

This report is intended to identify newly enrolled high school students that would normally have historical grades transferred but there are currently none in the storedgrades table. This report must be run from within a school.



Missing In Session Days


Data Management

This report is to list all active students without the COVID In Session Days. The report is intended to provide the missing Mon-Tue or Thu-Fri days of the week the student should be physically attending school based on the first letter in the last_name field. This information can be changed on the Covid Response Page but this report will not select the student if the field has

already been filled.



Missing Internet OR Media OR Birth Doc


Misc Student Listing

The purpose of this report is to list all students in a school that are missing either the Internet Policy, Media Policy or Birth Certificate/Passport. Please note this report is based on a document is uploaded and saved as an Internet or Media or Birth document. It does not read the actual document.

However, with the new online registration the Internet and Media policies questions are answered electronically. Therefore, if the parent has refused consent for either the student will be listed with an 'R' in either or both categories.

NOTE: You need to be in a school to run the report.



Missing Internet Policy or Media Release (PST)


Teachers (PST)

Must be in PowerTeacher

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

The purpose of this report is to list all students in a teacher's class that are missing either the Internet Policy or Media Policy. Please note this report is based on a document is uploaded and saved as an Internet or Media

document. It does not read the actual document.


Restricted

NRP OOD Students Current Year

Misc Student Listing

The purpose of this report is to list all students in NRP or OOD that were

enrolled in PowerSchool in the current year from 7/1 to 6/30.



NRP Student Report


Early Childhood

This report will list all active students and inactive students that have been exited within the current school year enrolled in the NRP school. Along with the student their status, grade level, SPED, Entry Comment, Exit Comment and person who created the record will also be displayed.


NRP Students with Alerts

Early Childhood

This report will list all active NRP students with an 'Alert - Other'



New Students By Date Range


Enrollment - School

Shows new students by date range for a school regardless of whether they are new to the district or transferred from another school. Run within a school.



New Students This Year


Bilingual

The purpose of this report is to identify ELL students that were newly registered in PowerSchool this year. However, to compensate for human error, included in the report are all students registering this year. The student's data contains their ELL and enrollment status and can be filtered to

provide a tailored listing.


New or Exited Pre-K Students

Early Childhood

The report will list all Pre-K students that have either enrolled in a Pre-K

school or exited from one during the specified date range.


Next Year Enrollment by Section

Next Year Reports

Shows the student enrollment of next year's courses when it sin't available in

PowerSchool because the first term hasn't started yet.

Restricted


Next Year Error Report for All Grades


Next Year Reports

This report lists students that may have an error with Next Year School and/or Next Year Grade.

NOTE: This report has been updated and must now be run within a school.



Next Year Error Report for District


Next Year Reports

This report displays that may prevent the End Of Year Roll-Up from running. The report lists errors and possible errors. For example, if the Next Year School is missing the Roll-Up will not run. However, if the next year grade is blank, this will translate to a 0 indicating Kindergarten. If an elementary student is in 7th grade and the next year grade is missing that student will be

a kindergartner come the fall.



Next Year Pre-K Enrollment Summary


Early Childhood

The intention of this report is to estimate the number of children that have been enrolled into Pre-K. The report is based on the number of pre-registered students for grades -1 and -2 along with any student currently registered and next year grade is Pre-K. The accuracy of this report is dependent on the staff enrolling students into PowerSchool before the end of the current school year and if current 3 year olds will return for Pre-K next year, the next year

grade is properly filled in.



Next Year School for 8th Graders


Next Year Reports

This report is primarily intended to be reviewed by counselors prior to the year end roll-up. The report will list all active 8th grade students along with their current homeroom, homeroom teacher, Next Grade, Next School and whether the student is to be scheduled by a Bridgeport District High School or not. Also included is a column to alert you to any possible errors. For example the student's Next Year Grade is 8 but his/her Term Report is marked "Retained - No" the error would read 'Should Next Grade be 9'.

You must be in a school to run this report.



No Shows


Attendance

This report is meant to determine those students that never arrived since the first day of school. The report is for an individual school. Please note for High Schools the Daily attendance must be updated first.

Since it is possible that a teacher didn't take attendance and therefore the student appears as Present, we have based the student output if their absences are within 75% of their membership days.



No Shows for District


Data Management

This report is meant to determine those students that never arrived since the first day of school. The report is for an individual school. Please note for High Schools the Daily attendance must be updated first.

Since it is possible that a teacher didn't take attendance and therefore the student appears as Present, we have based the student output if their absences are within 75% of their membership days.


Number of Years Student in HS

Misc Student Listing

Listing of active students from a high school and the number of years spent in

grades 9 through 12



OOD Bus Count by School


Transportation

This report lists all Out of District schools, such as charter and parochial schools, where we are busing our Bridgeport students to these other schools

and the total number of students being bused.



OOD Busing Summary


Data Management

This is a summary report to list all charter and parochial schools whose students in the Non Reporting Placement school are being bused or issued

GBT passes.


OOD Students with Alerts

Early Childhood

This report will list all active OOD students with an 'Alert - Other'



OOD and NRP Report


Data Management

This is the first cut of a report to list all active OOD and NRP students along with their OOD school they attend, SPED & ELL status as well as the

transportation fields that may be enabled.


Office Visits for a School

Health

This report will list all office visits for a school where the visit took place within

a specific date range.


Optimus Health Enrollment

Data Management

This report will list all schools with active enrollments in Optimus Health care

clinics.



Optimus Student Rosters (PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to produce a simple list of all students in one of the teacher's assigned classes which can be easily printed.


Restricted


Out of District Students


Enrollment - School

This report is intended to list all active students whose Resident Town Code is not Bridgeport (015) and is attending one of the Magnet Schools, Aero, Bio, IT, BMA or Discovery. The report will list the student's school as well as the current Home Address, including City, will be listed along with the Resident Town as it is recorded in PowerSchool.



Over Age and Wrong Grade


Grades

This report will show over aged high school students within the grade level and/or those students in the wrong grade level based on credits earned. The criteria for the various grade level ages and the Aged comments are as follows

"So_Aged" - Students older than 16 with less than 6.0 earned credits "Jr_Aged" - Students older than 17 with less than 12.5 earned credits "Sr_Aged" - Students older than 18 with less than 19.0 earned credits The "ERROR" field will indicate whether the student is "Older" or in the "Wrong Grade"

NOTE: You must run the report logged into a high school.



Overcrowding Listing


Control Transfers

This a list of all students who have been designated as attending a school in another neighborhood due to Overcrowding. Since the report is to be used for data cleaning, both active and inactive students are included.



Overcrowding No Longer at OC School


Control Transfers

Listing of students given transfers due to Overcrowding but no longer at the intended school.



Parent & Emergency Phone Numbers (PST)


Teachers (PST)

Must be in PowerTeacher

This is a listing of all phone numbers associated with each student in the selected class, including mother's & father's cell and home phones if living separate. Also included are all emergency contact numbers from the

enrollments.


Restricted


Parent emails by class to copy and paste (PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report group all parent and guardian emails from a single course into one field to copy and paste into an Outlook address 'TO' field.


Restricted


Pending Log Entries

Discipline and Other Log Entries

This report will replace the Pending Log Report on the Old Custom Reports tab. This reports the same log entries as distributed by the Crystal Reports.


Percent Scheduled for Next Year

Next Year Reports

This report provides the number of students by grade by sending school that

have requests scheduled for next year for the receiving school.



Perfect Attendance Within a Date Range


Attendance

The report will list all students without any absences within a date range. The list will include those students that may have been tardy during that period and they will be noted "TARDY". The report allows for filtering. If you want Perfect Attendance without these students, you can filter them out.


Please note you will need to be logged into a school. This does not work at District level.



Perfect Attendance for Homerooms


Attendance

This report is intended to show Elementary Homerooms that have Perfect attendance for a date range. For users with multiple school access, you will need to be in the school you want the attendance in. NOTE: Tardy and ISS are both Present codes and therefore a classroom would have Perfect Attendance even if students were tardy or in ISS.


Perfect Attendance for a School

Attendance

This is a listing of students within a specific school from the beginning of the

year to current day with Perfect Attendance.



Period to Day Attendance


Attendance

This report is intended to assist high schools to enter daily attendance for students that have missed 50% of the school day. It is run for each day and will display only those students that have missed more than half the school day based on their schedule. As a result, if a student has only 3 classes and misses 2 he will appear on the report an should be marked absent for the day. The learning prefernce (in-school vs distant) is listed on the report as well as the attendance codes that were recorded for the day in order to help you determine whether the student should be ABSNT or VAB for the day.



Pre-K Enrollment by School


Early Childhood

The report will list all the Pre-K classes within the District and, if specified, list the grant type, teacher, teacher designation, course number and section, course name, number enrolled, number available (based on maximums of 8 SPED, 15 for Discovery or 18), a status and whether a full day or half.



Pre-K Enrollment by School w/ Distance


Covid Related Reports

The report will list all the Pre-K classes within the District and, if specified, list the grant type, teacher, teacher designation, course number and section, course name, number enrolled, number available (based on maximums of 8 SPED, 15 for Discovery or 18), a status and whether a full day or half. This version of the report contains the Covid responses by parents. Those parents that responded 'Yes' are counted as 'In-School'. Those that replied 'No' or those that didn't reply are counted as 'Distance'.



Pre-K Household Summary


Early Childhood

This report will list only Pre-K students currently enrolled or recently exited in the School Readiness program. Contained in the report is the household information such as number of adults, children and income as captured from the online registration or input on the Early Childhood page. If the income was reported other than yearly, the report will calculate the yearly income and list the frequency times the number to get to yearly, i.e. weekly x 52.



Pre-K Student Enrollment w/ Distance


Covid Related Reports

This report lists all active and pre-registered students enrolled in a Pre-K classroom. Also listed is the teacher, teacher designation, classroom and whether the student has chosen Distance Learning, In-School or No

Response as a preference.



Primary Language or LDC Missing


Bilingual

This report will list all students from kindergarten through grade 12 that are missing either the Primary Language or LDC. The Primary Language is based on the primarylanguage field in the extended table StudentCoreFields.


Progress Report Grades Only

Grades

This report is intended to show only the Progress report grades in Stored

Grades table for the current year.


Purpose Summary

Student Support Services

Report to count the number visits by the Purpose of the Visit for the District.


Purpose of Visit by Student

Student Support Services

Listing of students for a selected school with a summary of their visits with a

count of the purpose of their.


Recently Entered Students

Health

Purpose of this report is to alert nurses to any new students entering their

school



Report Card Archive Summary


District

This report will list all schools and the total of currently active students, the name of each archived report card, the date they were created and the

number of report cards archived for that report card.



Resident Town Code Errors


Enrollment - School

This report is intended for use by the Inter-district Magnet schools to identify only those students that may have errors in the District of Residence and/or the Resident Town code (RTC). Errors will include missing or incorrect RTC codes, misspelling of town/city names. In addition, the report will indicate the SPED status and Homeless status of the student. NOTE: This report must be

run within a school.



Resident Town Code for a School


Enrollment - School

This report is school based and lists students, the city where they live, the Resident Town Code (RTC), and the name of the city for the Resident Town Code. This will help identify errors before reporting to the State.



Review Students for Next Year Placement


Next Year Reports

Developed for Skane, the purpose of this report is to list all active students and specific information and their next year school and grade and a blank

field to include their next program.



Roster for Teams Meeting (PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report group all emails from a single course into one field to copy and paste into a Teams or Outlook address 'TO' field.


Restricted


Rosters for NGSS


Enrollment - Course

This report lists all students, along with the teacher, enrolled in any Science

course in the current school year for a particular school. Any student enrolled in a course number beginning with "SC" is selected.



Rosters for SBAC


Enrollment - Course

This report lists all students, along with the teacher, enrolled in an English or Math course in the current school year for a particular school. Any student enrolled in a course number beginning with "EN" or

"MA" is selected.



Rosters for Social Studies


Enrollment - Course

This report lists all students, along with the teacher, enrolled in any Social Studies course in the current school year for a particular school. Any student

enrolled in a course number beginning with SS is selected.


SBAC Tests by Grade Level

Uncategorized

This is an experimental test to collect SBAC scores for a grade for the school

you are presently in PowerSchool.



SEDAC-G Export for Dianny


Finance

When updating SEDAC-G financial information for students that have already been reported, this report will pull the updated information from the OOD

Financial page in PowerSchool.



School Messenger Email Summary


District

This report is intended to list all schools and the number of students enrolled. Along with the number of School Messenger emergency emails that are

student emails and the number of missing emails.


Restricted

Search - Custom Pages (CPM)

Data Management

Find in which Custom Page(s) (CPM) a specific string is found.

Restricted


SPED Error Report


Misc Student Listing

Report to list SPED indicator = Y without a Student Disability Designation (SDD) and SPED = N with a Student Disability Designation (SDD)



SPED Students Within a School


Misc Student Listing

Lists all SPED students by grade level with Contact being the Homeroom Teacher or Responsible Admin and/or Counselor as well as the Case Managers.

Newly added is the CEP column. Continued Educational Plan (CEP) are the documents uploaded to Attachments so as not to interfere with the FrontLine IEP plans which are in place.


NOTE: You must be in a school to run this report.


Schedule of Days Off for a School

Scheduling

This report will list the days with no school scheduled for the current entire

school year for a specific school, including snow days.



ScheduleCC Report from PowerScheduler


Next Year Reports

The intention of this report is to give an Admin the ability to see students' next year schedules, as long as the Admin has Loaded the courses with students in PowerScheduler. The program is written from the time before the End Of Year Rollup. Once the Rollup has been done and the "Current" year is set to the next year, this report will fail. One other note, depending on the size of the school, may take longer to run. As a result, the report may appear finished but until the alternating blue strips appear, the report is still building. A warning may appear warning your browser has slower due to the page, just ignore.

Lastly, you must be in a school to run the report.



Scheduling Dependent Sections


Bassick

The report is intended for Bassick use only in determining the enrollment of students in courses with dependent sections. The program currently only

works if there is only one dependent section.


Scheduling Teams Enrollment

Bassick

This report is intended exclusively for Bassick to aid in scheduling the 2020-

2021 School Year.



School Days for All Schools


District

This report will list Bridgeport Public Schools and the number of days in session for the students within the current school year. This report counts

only days that students should be in school for the current year.



School Listing of Medical Alerts


Health

This is a listing of all students within the school you are logged into that have Medical Alerts and the date when the alert expires. Note that you must be in the school you want the listing of. Also, only students with Medical Alerts that exist on the Emergency Contact/Medical page will appear on the report.



School Listing with Learning Preference


Covid Related Reports

Elementary school listing of all students within a school and their homeroom teacher along with the learning preference chosen by the parent, in-school vs. distant, as well as grade, SPED, ELL and School Messenger contact info.

RUN WITHIN A SCHOOL



Sections Taught Current Year (PST)


Teachers (PST)

Must be in PowerTeacher

This report is intended to show the logged in teacher all classes he/she is assigned to teach for the current year. In addition to the course number, section number, course name, term length, section ID and number of active

students. NOTE: You must be logged in as a teacher.


Restricted


School Messenger Student Email & Phone


School_Messenger

This report is intended to show all School Messenger emails and phone numbers currently listed on the student's Demographics page within a school.

The report must be run within a school and not at District Office.



School Present Count


Attendance

This report will show the number of students present, absent and enrolled in a schools on any school day for any year. The report must be run from within a

school.



School Present Count with Remote


Attendance

This report will show the number of students present and absent for both In School and Distant Learning for a school on a specific day. The report must

be run from within a school.



School Summary by Grade With Bilingual and SPED


Bilingual

This report will breakdown the Portuguese ELL, ELL less Portuguese, Students in a Bilingual class, SPED students in a Self Contained class and all SPED less those in Self Contained classes.

Please note:


  1. You must be in a school to run report.

  2. The Portuguese count is based off of the Primary Language.

    If the Primary Language is "003" the student will be counted as Portuguese.

  3. Students in a Bilingual class are counted if the student is ELL and has classes given by a teacher designated as "Bilingual".

  4. Similarly, SPED students in a class given by a teacher designated as "SPED-SC" will be counted as Self Contained.


SEDAC-G Export for Dorothy

Finance

This export is still in testing and is intended to fit into Dorothy's spreadsheet.

Restricted

SEDAC-G Export for PJ

Finance

This export is still in testing and is intended to fit into PJ's spreadsheet.

Restricted

Service Summary if Referred

Student Support Services

A summary of services provided by school for students with a Referral for the

District.


Service Summary if Referred and Accessed

Student Support Services

A summary of Services by school rendered only if Referred and Accessed for

the District.


Service Summary other than Referred

Student Support Services

A summary of services provided by school for students other than Referred

for the District.



Sibling Report


Enrollment - School

This report is intended to list active students within a specific school that the school had identified their siblings. The report allows you to select all siblings whether they are activly enrolled in a school or not. Warning: You must identify the sibling before running this report and the report must be run from

within a school.



Special Attendance Report


Attendance

Listing of students with any data on the Special Attendance page in PowerSchool.

MUST BE RUN WITHIN A SCHOOL.



Staff With Classes


Staff

The purpose of this report is to identify staff members with active classes who may be a certified teacher whose 'staffstatus' is 'staff' instead of 'teacher'. The security group the staff member is in will help determine if the individual had been certified but has now taken a new position.



Staff email Errors


Data Management

The purpose of this report is to list all active staff members and access to PowerSchool or PowerTeacher that may have an erroneous email address based on their LDAP login user name. When reviewing account for errors be sure to remove login ID and the LDAP indicator for PowerSchool or

PowerTeacher that is not being used.


Stored Grade Failures

Grades

Shows all Failed or Incomplete courses grades for the Y1 term and the

students who have failed in alpha order by Course



Stored Grades Listing


Bassick

This report lists all records in the Historic Grades table by teacher, student, course and grades for a specific marking period of the current year.


NOTE: This report must be run from within a school.


ALSO NOTE: Since these records are from the stored grades table, counselors would be adding grades for new students coming in from outside of our District. These grades may not include the teacher name or a name not familiar to the present school. However, the report can be filtered to eliminate those records.



Stored Grades Listing


Grades

This report lists all records in the Historic Grades table by teacher, student, course and grades for a specific marking period of the current year.


NOTE: This report must be run from within a school.


ALSO NOTE: Since these records are from the stored grades table, counselors would be adding grades for new students coming in from outside of our District. These grades may not include the teacher name or a name not familiar to the present school. However, the report can be filtered to eliminate those records.


Stored Grades for Current Year

Grades

Report lists every student with a stored grade for any subject within the

current year.



Stored Grades for Select Term


Grades

This report must be executed within a school. The school year must also be set in PowerSchool at the top right hand side of page. This report will list the stored grades of all students for a given Term. These Terms are based on

the terms set for the school and school year.



Stored Letter Grades with Wrong Percent


Grades

The purpose of this report is to show errors between the Letter Grade and what should be the range of the Percent Grade for that Letter Grade.



Student & Parent Emails (PST)


Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to list all students in one of the teacher's assigned classes with all the School Messenger and parent contacts in one location. The list can be sorted and filtered. Although the report can be printed, due to the number of columns, it is recommended to export the data

to a "CSV" file. This file can be opened with Excel.


Restricted


Student Absences for a Class (PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to list the students within the class that have more than 4 absences for this class.


Restricted


Student Emails


Misc Student Listing

The results will be all emails associated with the active students in the school, including parents, guardian emails and the student's Bridgeport email or the one he/she has entered. Also included is the School Messenger phone contacts in case there are no email addresses given for the student.

This report must be run from within a school.



Student Enrollment Distant or In School (PST)


Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to list all students in one of the teacher's assigned classes with student's name, grade, homeroom, if applicable and whether the student is a distant learner or in-school. Since all in-school students will be returning to meeting Monday, Tuesday, Thursday and Friday with remote learning on Wednesday the column 'In Session Days' has been

remove to eliminate confusion.


Restricted


Student Enrollment History


Uncategorized

The report is intended to show a student's enrollment history from the very first year in Bridgeport School System. Along with the year is the school or schools attended, grade level, membership, absences and final courses and grades at the school.

You must select a student or students BEFORE running this report.

However, currently this report can only retrieve this information back to 2012- 2013 school year.


Student High School Course Requests

Scheduling

This report will list all the student requests currently entered into

PowerSchool. You must be in a High School to retrieve the information.


Student List with Language in a School

Bilingual

This is a listing of all students within a school and their language as reported

in the student's record as Primary Language.



Student List with Tardy Count


Attendance

This report will list students within a school that have been tardy at least once in the current school year along with the total number of times the student was tardy for the day since the beginning of school to present.

NOTE: You must run this report within a school.



Student Listing with a Count of OSS Sanctions

Discipline and Other Log Entries

Purpose of this report is to listing only those students with at least 1 OSS sanction within the current school year. NOTE: this report is school based

and must be run within a school.



Student Log Entries (PST)


Teachers (PST)

Must be in PowerTeacher

This report is written specifically for PowerTeacher do not run as PowerSchool Admin.

A list of all log types for a student except Health and Social Work will be

produced.


Restricted


Student Membership & Absence


Attendance

This report will list membership and absences for active students within a school for the current school year. Along with attendance, the student's grade level, age, home language and the percentage of absences.

NOTE: You must be logged into a school.



Student Membership and Absences by Date Range


Attendance

This report will list membership and absences for active students within a school for the current school year within a date range. Along with attendance, the student's grade level, age, homeroom and homeroom teacher are listed. NOTE: You must be logged into a school.



Student Rosters (PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to produce a simple list of all students in one of the teacher's assigned classes which can be easily printed.


Restricted


Student SBAC Testing Report(PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to list all students in one of the teacher's assigned classes with the student's State Assigned Student ID (SASID) in

order for the student to sign into the SBAC testing sight.


Restricted


Student Schedule with Rooms by Period for S1


Enrollment - Course

The report will list all enrolled students with the rooms they will be in for the 4 periods of a blocked schedule. Also included is their grade level, responsible

admin, and counselor.


Student Search by Date of Birth

A New Student Search

Purpose of this report is to search the entire student table for all records that

match the entered date of birth.



Student Summary By School Including NRP


Transportation

This report is indented to list all active students attending a school including those students at charter and parochial schools listed under the NRP school. These student will have the school indicator within their record and will be accounted for under the abbreviation. This is to enable a comparison between PowerSchool and TransFinder.

NOTE: Since TransFinder uses the school's abbreviation as the key, this run

uses the same abbreviations.


Student Support Visit Summary by Staff Position

Student Support Services

Summary of the number of visits by the staff position for the District.


Student Test Scores

Uncategorized

A list of test scores a student has taken grouped by test.



Student Test Scores (PST)

Teachers (PST)

Must be in PowerTeacher

A list of test scores a student has taken grouped by test.


Restricted


Student Testing Report(PST)

Teachers (PST)

Must be in PowerTeacher

The purpose of this report is to list all students in one of the teacher's assigned classes with the student's study ID in order for the student to sign

into the Testing sight.


Restricted


Student Transferred Out But Not Yet Enrolled


Scheduling

This report lists all students within a selected school that have been transferred out with an exit code of "01" or have been transferred into the selected school with an "01" without being enrolled into the receiving school.


Student Visits by Time for District

Student Support Services

Summary of when students visit by morning, after lunch and after school for

the entire District.


Student Visits by Time for a School

Student Support Services

Summary of when students visit by morning, after lunch and after school for a

school selected at the beginning of the report.



Student's Pending Status


Covid Related Reports

This report is intended to alert the school to enrolled students who are expected to either return to In-School or move to Distant Learning. The report was created to check the 'Expected Return to in-school learning' date and the 'Moving to Distant Learning on' date on the COVID Survey screen.

This report adds the flexibility to enter your own search dates.



Students Expected to Return


Covid Related Reports

This report is intended to alert the school to enrolled students who are expected to return ti in-school learning in advance for their return date. The report was created to check the Covid Expected Return Date on the Survey

screen and 7 days ahead.



Students Not Pointed to Same HS Next Year


Next Year Reports

In preparation for the End of Year Roll-up, this report lists all students in grades 9 through 12 whose Next Year School is not the same as their present school. This situation occurs when a student transfers from one school to another and the "Scheduling Setup" page is not modified to reflect the new

school.


Restricted


Students Repeating Grade


Misc Student Listing

Report displays students within a school repeating the same grade based on a comparison of current grade level stored grade level from previous school

year.



Students Requesting Translation


Home Language Survey

This is a listing of all active students within the District that have answered "Yes" to question 5 or 6 on the Home Language Survey which is requesting a

translation or an interpreter.



Students Requesting Translation Summary


Home Language Survey

This is summary report for all active students District wide which have requested communications to be translated or have requested an interpreter

for meetings.



Students Without Classes


Scheduling

This report will list all students currently enrolled in school but have not been assigned any classes. At present the BJDC has been omitted form this

report.



Students Without Classes


Enrollment - Course

The report is designed to show active students who are not enrolled in any classes.

NOTE: You must be logged into a school, will not work in District.


Students Without Classes in District

Data Management

This report will list all students within the District that do not have any classes

assigned to them.



Students Without Requests


Next Year Reports

This report will list all students that are checked for scheduling on their 'Scheduling Setup' page but do not have any course requests for next year.



Students and Parent Access Accounts


Misc Student Listing

This report will list the entire student population and any parent/guardian access accounts they may have. The report allows you to filter by grade and those with and without parent accounts. If a student has more than one

parent account these will be grouped together by the student.



Students in Wrong Grade by Credit Hrs


Counselors

The intention of this report is to list those students whose current grade level does not correspond to the grade level as defined by their earned credits.The first year of high school is calculated from the historical grades table. Using the earliest recorded year for grades stored when student was in 9th grade. If the student transferred into a Bridgeport high school, it is imperative the guidance counselor record the correct and complete information into the historical grades table. In addition, the report calculates if the student has repeated a grade by subtracting the student's first year of high school from the current school year and comparing the difference.

The data displayed in the report is the student number, name, 1st year of high school,repeat or not, current grade, DOB, age, SPED, ELL, number of credits earned and what the grade should be based on the credits.

NOTE: The grade level from credits is based on whether the student started school before 2019 when the required credits to graduate was 22.5 or after when the credits required are 25.

Also, this report does take a few minutes to run and must be run within a school.


Students missing Ethnicity/Race

Misc Student Listing

Just as the title indicates, this report lists all active students throughout the

District where the race and ethnicity fields are missing data.


Students with Allergies

Health

List all active students within a school where the allergy field has been filled in

from the student's Emergency Contact/Medical page.

Restricted


Students with Outstanding Invoices


Covid Related Reports

The purpose of this report is to list students that may have a payment for repairs due on a school device. The invoice amount is entered in the Covid Survey page. It is meant to keep track of students that may owe money to the school for repairs. If more than one invoice is owed, the amount should be the sum of all invoices owed.

MUST BE RUN WITHIN A SCHOOL


Students with Support Visits

Student Support Services

List all students with any Support Service records within a time range


Summer School Home School to SS

Summer School

List students from your school who are attending a summer school


Summer School Home School to SS - District

Summer School

List students from the District who are attending a summer school

Restricted

Summer School Students

Summer School

This report will list all students that have been recommended for Summer

School.



Summer School Summary


Summer School

This report will count the students in Kindergarten to grade 3 and registered to a school school by the summer school. Although the report contains the count of students tagged in PowerSchool attending ESY, the Dept. of Specialize Instruction provides its own list of ESY students.


Summer School To Home School

Summer School

List of students from throughout the District attending your summer school



Suspension Rates


Discipline and Other Log Entries

This report displays the Suspension Rate for each school in the District. This rate is calculated by counting the students that have an ISS, OSS or Expulsion from the school where the incident took place divided by the total number of students attending a school within the current school year, whether currently active or not.

NOTE: Since discipline logs are constantly being updated to report sanctions of ISS, OSS and Expulsions, the results of this report can change daily.


Talented and Gifted (TAG)

Misc Student Listing

Lists all students identified on the State page that have a TAG code (02

through 09)



Teachers with Classes


Staff

Using the class sections for all Bridgeport schools for the current year, the report will list every teacher designated as Lead Teacher within a school, along with the school they are teaching at and their email address.

NOTE: If a teacher is teaching classes in more than one school, the teacher will be listed in all the school he/she teaches in.



Top 5 Disciplinary Incidents by School


Discipline and Other Log Entries

This report will list the top 5 ranked incidents regardless of any sanction which may or may not have occurred. NOTE: If two or more incident types have the same number of violations the Rank number will be the same and the top 5 will be shown. Therefore, it is possible to have more than 5 incident

types listed.


sqlReports Information

Uncategorized

List of reports in sqlReports by category, including access groups and last

time they were run.



~SSEL Attendance Taken for a Day


Summer School

NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool.

The report will list all schools and the attendance totals for a specific day.



~SSEL School Summary by Team


Summer School

NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool.

This report will count all the students actively enrolled in the Elementary Summer school by the school they were enrolled in at the end of the current school year.



~SSEL Student List by Enrollment


Summer School

NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool.

Summer School students enrolled in a course represents the Summer School the student is attending. This report lists each active student with the school abbreviation they attended during their normal school year (represented by Team) along with the Summer School they are currently attending.



~SSEL Student Not in a Summer School


Summer School

NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool.

This report lists all students active in the Summer School but are not enrolled in a Summer School. Also listed as Home School is where the student attended during regular school year.



~SSEL Students Enrolled in more than 1 School


Summer School

NOTE: This report is to be run on the Summer School Server only. It is NOT intended to be used in the normal production PowerSchool.

This report is to identify those students enrolled in more than one Summer School at the same time. Having a student enrolled in more than one course will cause the SSEL Student List by Enrollment and SSEL Student Not in a Summer School Reports not to run.